FaPellRFMSImportWork

EntityType | Independent
Logical Entity Name | FaPellRFMSImportWork
Default Table Name | FaPellRFMSImportWork
Logical Only | NO
Owner | dbo
Definition |
Note |

FaPellRFMSImportWork Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
FaPellRFMSImportWorkID |  | INTEGER | NO |
ErrorMessage |  | CHAR(60) | YES |
OldAmount |  | MONEY(19, 4) | YES |
NewAmount |  | MONEY(19, 4) | YES |
SyStudentID |  | INTEGER | YES |
OriginationID |  | CHAR(26) | YES |
Status |  | CHAR(15) | YES |
OrigRejectCodes |  | CHAR(75) | YES |
OriginationFlags |  | CHAR(10) | YES |
SSN |  | CHAR(11) | YES |
FileName |  | CHAR(70) | YES |
PellID |  | CHAR(10) | YES |
OriginationBatchID |  | CHAR(26) | YES |
DateAdded |  | DATETIME | YES |
DateLstMod |  | DATETIME | YES |
WorkstationID |  | CHAR(40) | YES |
UserID |  | INTEGER | YES |
ARCode |  | CHAR(1) | YES |
Ref |  | CHAR(2) | YES |
TransactionID |  | CHAR(13) | YES |
PendingAmount |  | MONEY(19, 4) | YES |
RecordsDuplicated |  | INTEGER | YES |
ts |  | TIMESTAMP/DATE | NO |

FaPellRFMSImportWork Keys

Key Name | Key Type | Keys
FaPellRFMSImportWork_FaPellRFMSImportWorkID_U_C_IDX | PrimaryKey | FaPellRFMSImportWorkID

FaPellRFMSImportWork Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

FaPellRFMSImportWork Check Constraints

Check Constraint Name | CheckConstraint

FaPellRFMSImportWork Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaPellRFMSImportWork | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaPellRFMSImportWork | NO |  |  |

FaPellRFMSImportWork Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaPellRFMSImportWork Data Movement Rules

Name | Type | Rule Text/Value